-- Example showing WITH OUTPUT on INSERT of table data w/ Identity

SET NOCOUNT ON

INSERT Test (Data) VALUES ('Foo')
INSERT Test (Data) SELECT Data FROM Test
SELECT @@Identity
SELECT * FROM Test

DECLARE @NewRows TABLE (IdentityJustAssigned int, Data varchar(20))
INSERT Test (Data) 
       OUTPUT Inserted.ID, Inserted.Data INTO @NewRows
       SELECT Data FROM Test
SELECT * FROM @NewRows
